| FaStudentLoanPeriod |
| Logical Entity Name | FaStudentLoanPeriod |
| Default Table Name | FaStudentLoanPeriod |
| Physical Only | NO |
| Definition | |
| Note |
| FaStudentLoanPeriod Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaStudentLoanPeriodID |
int | NO | ||
AdEnrollID |
int | NO | ||
| Sequence | int | NO | ||
| StartDate | datetime | NO | ||
| EndDate | datetime | NO | ||
| AwardYear1 | varchar(7) | NO | ||
| AwardYear2 | varchar(7) | YES | ||
| PackageDate | datetime | YES | ||
| WeeksInLP | numeric(4, 1) | YES | ||
| MonthsInLP | numeric(4, 1) | YES | ||
| WeeksNonEnroll | numeric(4, 1) | YES | ||
| WeeksEnrolledInLP | numeric(4, 1) | YES | ||
| CreditHoursInLP | numeric(7, 2) | NO | ||
| CreditHoursExpToComplete | numeric(7, 2) | YES | ||
| CostOfAttend | money | YES | ||
| InstitutionalCharges | money | YES | ||
| Tuition | money | YES | ||
| BooksSupplies | money | YES | ||
| RoomBoard | money | YES | ||
| Travel | money | YES | ||
| BankFees | money | NO | ||
| OtherDescrip1 | varchar(40) | YES | ||
| OtherAmount1 | money | YES | ||
| OtherInst1 | bit | NO | ||
| OtherDescrip2 | varchar(40) | YES | ||
| OtherAmount2 | money | YES | ||
| OtherInst2 | bit | NO | ||
| OtherDescrip3 | varchar(40) | YES | ||
| OtherAmount3 | money | YES | ||
| OtherInst3 | bit | NO | ||
| OtherDescrip4 | varchar(40) | YES | ||
| OtherAmount4 | money | YES | ||
| OtherInst4 | bit | NO | ||
| OtherDescrip5 | varchar(40) | YES | ||
| OtherAmount5 | money | YES | ||
| OtherInst5 | bit | NO | ||
| OtherDescrip6 | varchar(40) | YES | ||
| OtherAmount6 | money | YES | ||
| OtherInst6 | bit | NO | ||
| OtherDescrip7 | varchar(40) | YES | ||
| OtherAmount7 | money | YES | ||
| OtherInst7 | bit | NO | ||
| OtherDescrip8 | varchar(40) | YES | ||
| OtherAmount8 | money | YES | ||
| OtherInst8 | bit | NO | ||
| Comment | varchar(4000) | YES | ||
| PackagedToAdAttStatID | int | YES | ||
| unsubeligibilityuptoheal | bit | NO | ||
| UnsupportedDependent | bit | NO | ||
| ExcludeSummerPackaging | bit | NO | ||
| HPPALevel | char(1) | NO | ||
| PLUSCreditDecisionStatus | char(1) | YES | ||
| ReentryLP | bit | NO | ||
| ExcludeStartDateFromAutoAdjust | bit | NO | ||
| ExcludeEndDateFromAutoAdjust | bit | NO | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
| AdGradeLevelID | int | NO | ||
| BBAYStartDate | datetime | YES | ||
| BBAYEndDate | datetime | YES | ||
| IWINLP | numeric(4, 1) | NO | ||
| IWMonths | numeric(4, 1) | NO | ||
| RefWeeksInLP | numeric(4, 1) | YES | ||
| RefCreditHoursInLP | numeric(7, 2) | YES | ||
| IsStubLoanPeriod | bit | NO | ||
| ScheduledComplete | bit | NO |
| FaStudentLoanPeriod Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_FaStudentLoanPeriod_FaStudentLoanPeriodID | PrimaryKey | FaStudentLoanPeriodID |
| FaStudentLoanPeriod Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdEnroll | Non-Identifying | One To Zero or More | FK_FaStudentLoanPeriod_AdEnrollID_AdEnroll_AdEnrollID | AdEnrollID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_FaStudentLoanPeriod_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaStudAyDlDateReview | Non-Identifying | One To Zero or More | FK_FaStudAyDlDateReview_FastudentLoanPeriodID_FastudentLoanPeriod_FastudentLoanPeriodID | NO | YES | |||
| FaStudentLPPaymentPeriod | Non-Identifying | One To Zero or More | FK_FaStudentLPPaymentPeriod_FaStudentLoanPeriodID_FaStudentLoanPeriod_FaStudentLoanPeriodID | NO | YES |
| FaStudentLoanPeriod Check Constraints |
| Check Constraint Name | CheckConstraint |